package com.teamall.web.sjtj.db.arg;

import java.util.*;
import java.math.*;
import org.apache.commons.lang.*;

public class CodeVisitedTeamRankArg {
    private String pk_name = "vid";

    private String orderByClause;

    private String groupByClause;

    private String columns;

    private String countsql1;

    private String countsql2;

    private boolean distinct;

    private int rowStart = 0;

    private int rowEnd = 10;

    private List<CodeVisitedTeamRankCriteria> oredCriteria;

    public CodeVisitedTeamRankArg() {
        oredCriteria = new ArrayList<CodeVisitedTeamRankCriteria>();
    }

    public void setPk_name(String pk_name) {
        this.pk_name = StringEscapeUtils.escapeSql(pk_name);
    }

    public String getPk_name() {
        return pk_name;
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = StringEscapeUtils.escapeSql(orderByClause);
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = StringEscapeUtils.escapeSql(groupByClause);
    }

    public String geGroupByClause() {
        return groupByClause;
    }

    public void setColumns(String columns) {
        this.columns = StringEscapeUtils.escapeSql(columns);
    }

    public String geColumns() {
        return columns;
    }

    public void setCountsql1(String countsql1) {
        this.countsql1 = StringEscapeUtils.escapeSql(countsql1);
    }

    public String geCountsql1() {
        return countsql1;
    }

    public void setCountsql2(String countsql2) {
        this.countsql2 = StringEscapeUtils.escapeSql(countsql2);
    }

    public String geCountsql2() {
        return countsql2;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public void setRowStart(int rowStart) {
        this.rowStart = rowStart;
    }

    public void setRowEnd(int rowEnd) {
        this.rowEnd = rowEnd;
    }

    public int getRowStart() {
        return rowStart;
    }

    public int getRowEnd() {
        return rowEnd;
    }

    public List<CodeVisitedTeamRankCriteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(CodeVisitedTeamRankCriteria criteria) {
        oredCriteria.add(criteria);
    }

    public CodeVisitedTeamRankCriteria or() {
    	CodeVisitedTeamRankCriteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public CodeVisitedTeamRankCriteria createCriteria() {
    	CodeVisitedTeamRankCriteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected CodeVisitedTeamRankCriteria createCriteriaInternal() {
    	CodeVisitedTeamRankCriteria criteria = new CodeVisitedTeamRankCriteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        groupByClause = null;
        columns = null;
        countsql1 = null;
        countsql2 = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<CodeVisitedTeamRankCriterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<CodeVisitedTeamRankCriterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<CodeVisitedTeamRankCriterion> getAllCriteria() {
            return criteria;
        }

        public List<CodeVisitedTeamRankCriterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new CodeVisitedTeamRankCriterion(condition));
        }

        protected void addCriterion(String condition, Object value,
                String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new CodeVisitedTeamRankCriterion(condition, value));
        }

        protected void addCriterion(String condition, Object value,
                String property, int likeType) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new CodeVisitedTeamRankCriterion(condition, value, likeType));
        }

        protected void addCriterion(String condition, Object value1,
                Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property
                        + " cannot be null");
            }
            criteria.add(new CodeVisitedTeamRankCriterion(condition, value1, value2));
        }

        public CodeVisitedTeamRankCriteria andCriterionEqualTo(String criterion) {
            if (StringUtils.isBlank(criterion)) {
                criterion = "1=1";
            }
            addCriterion(criterion);
            return (CodeVisitedTeamRankCriteria) this;
        }
        public CodeVisitedTeamRankCriteria andVidIsNull() {
            addCriterion("vid is null");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVidIsNotNull() {
            addCriterion("vid is not null");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVidEqualTo(String value) {
            addCriterion("vid =", value, "vid");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVidNotEqualTo(String value) {
            addCriterion("vid <>", value, "vid");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVidGreaterThan(String value) {
            addCriterion("vid >", value, "vid");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVidGreaterThanOrEqualTo(String value) {
            addCriterion("vid >=", value, "vid");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVidLessThan(String value) {
            addCriterion("vid <", value, "vid");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVidLessThanOrEqualTo(String value) {
            addCriterion("vid <=", value, "vid");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVidLike(String value) {
            addCriterion("vid like ", value, "vid", 1);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVidNotLike(String value) {
            addCriterion("vid  not like ", value, "vid", 1);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVidLeftLike(String value) {
            addCriterion("vid like ", value, "vid", 0);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVidNotLeftLike(String value) {
            addCriterion("vid  not like ", value, "vid", 0);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVidRightLike(String value) {
            addCriterion("vid like ", value, "vid", 2);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVidNotRightLike(String value) {
            addCriterion("vid  not like ", value, "vid", 2);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVidIn(List<String> values) {
            addCriterion("vid  in ", values, "vid");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVidNotIn(List<String> values) {
            addCriterion("vid not in ", values, "vid");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVidBetween(String value1, String value2) {
            addCriterion("vid between ", value1, value2, "vid");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVidNotBetween(String value1, String value2) {
            addCriterion("vid not between ", value1, value2, "vid");
            return (CodeVisitedTeamRankCriteria) this;
        }
        public CodeVisitedTeamRankCriteria andVisitedCountSumIsNull() {
            addCriterion("visited_count_sum is null");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVisitedCountSumIsNotNull() {
            addCriterion("visited_count_sum is not null");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVisitedCountSumEqualTo(BigDecimal value) {
            addCriterion("visited_count_sum =", value, "visited_count_sum");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVisitedCountSumNotEqualTo(BigDecimal value) {
            addCriterion("visited_count_sum <>", value, "visited_count_sum");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVisitedCountSumGreaterThan(BigDecimal value) {
            addCriterion("visited_count_sum >", value, "visited_count_sum");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVisitedCountSumGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("visited_count_sum >=", value, "visited_count_sum");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVisitedCountSumLessThan(BigDecimal value) {
            addCriterion("visited_count_sum <", value, "visited_count_sum");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVisitedCountSumLessThanOrEqualTo(BigDecimal value) {
            addCriterion("visited_count_sum <=", value, "visited_count_sum");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVisitedCountSumLike(BigDecimal value) {
            addCriterion("visited_count_sum like ", value, "visited_count_sum", 1);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVisitedCountSumNotLike(BigDecimal value) {
            addCriterion("visited_count_sum  not like ", value, "visited_count_sum", 1);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVisitedCountSumLeftLike(BigDecimal value) {
            addCriterion("visited_count_sum like ", value, "visited_count_sum", 0);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVisitedCountSumNotLeftLike(BigDecimal value) {
            addCriterion("visited_count_sum  not like ", value, "visited_count_sum", 0);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVisitedCountSumRightLike(BigDecimal value) {
            addCriterion("visited_count_sum like ", value, "visited_count_sum", 2);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVisitedCountSumNotRightLike(BigDecimal value) {
            addCriterion("visited_count_sum  not like ", value, "visited_count_sum", 2);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVisitedCountSumIn(List<BigDecimal> values) {
            addCriterion("visited_count_sum  in ", values, "visited_count_sum");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVisitedCountSumNotIn(List<BigDecimal> values) {
            addCriterion("visited_count_sum not in ", values, "visited_count_sum");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVisitedCountSumBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("visited_count_sum between ", value1, value2, "visited_count_sum");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVisitedCountSumNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("visited_count_sum not between ", value1, value2, "visited_count_sum");
            return (CodeVisitedTeamRankCriteria) this;
        }
        public CodeVisitedTeamRankCriteria andVillageIdIsNull() {
            addCriterion("VILLAGE_ID is null");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageIdIsNotNull() {
            addCriterion("VILLAGE_ID is not null");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageIdEqualTo(Integer value) {
            addCriterion("VILLAGE_ID =", value, "VILLAGE_ID");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageIdNotEqualTo(Integer value) {
            addCriterion("VILLAGE_ID <>", value, "VILLAGE_ID");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageIdGreaterThan(Integer value) {
            addCriterion("VILLAGE_ID >", value, "VILLAGE_ID");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("VILLAGE_ID >=", value, "VILLAGE_ID");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageIdLessThan(Integer value) {
            addCriterion("VILLAGE_ID <", value, "VILLAGE_ID");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageIdLessThanOrEqualTo(Integer value) {
            addCriterion("VILLAGE_ID <=", value, "VILLAGE_ID");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageIdLike(Integer value) {
            addCriterion("VILLAGE_ID like ", value, "VILLAGE_ID", 1);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageIdNotLike(Integer value) {
            addCriterion("VILLAGE_ID  not like ", value, "VILLAGE_ID", 1);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageIdLeftLike(Integer value) {
            addCriterion("VILLAGE_ID like ", value, "VILLAGE_ID", 0);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageIdNotLeftLike(Integer value) {
            addCriterion("VILLAGE_ID  not like ", value, "VILLAGE_ID", 0);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageIdRightLike(Integer value) {
            addCriterion("VILLAGE_ID like ", value, "VILLAGE_ID", 2);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageIdNotRightLike(Integer value) {
            addCriterion("VILLAGE_ID  not like ", value, "VILLAGE_ID", 2);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageIdIn(List<Integer> values) {
            addCriterion("VILLAGE_ID  in ", values, "VILLAGE_ID");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageIdNotIn(List<Integer> values) {
            addCriterion("VILLAGE_ID not in ", values, "VILLAGE_ID");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageIdBetween(Integer value1, Integer value2) {
            addCriterion("VILLAGE_ID between ", value1, value2, "VILLAGE_ID");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageIdNotBetween(Integer value1, Integer value2) {
            addCriterion("VILLAGE_ID not between ", value1, value2, "VILLAGE_ID");
            return (CodeVisitedTeamRankCriteria) this;
        }
        public CodeVisitedTeamRankCriteria andVillageNameIsNull() {
            addCriterion("VILLAGE_NAME is null");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageNameIsNotNull() {
            addCriterion("VILLAGE_NAME is not null");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageNameEqualTo(String value) {
            addCriterion("VILLAGE_NAME =", value, "VILLAGE_NAME");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageNameNotEqualTo(String value) {
            addCriterion("VILLAGE_NAME <>", value, "VILLAGE_NAME");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageNameGreaterThan(String value) {
            addCriterion("VILLAGE_NAME >", value, "VILLAGE_NAME");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageNameGreaterThanOrEqualTo(String value) {
            addCriterion("VILLAGE_NAME >=", value, "VILLAGE_NAME");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageNameLessThan(String value) {
            addCriterion("VILLAGE_NAME <", value, "VILLAGE_NAME");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageNameLessThanOrEqualTo(String value) {
            addCriterion("VILLAGE_NAME <=", value, "VILLAGE_NAME");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageNameLike(String value) {
            addCriterion("VILLAGE_NAME like ", value, "VILLAGE_NAME", 1);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageNameNotLike(String value) {
            addCriterion("VILLAGE_NAME  not like ", value, "VILLAGE_NAME", 1);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageNameLeftLike(String value) {
            addCriterion("VILLAGE_NAME like ", value, "VILLAGE_NAME", 0);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageNameNotLeftLike(String value) {
            addCriterion("VILLAGE_NAME  not like ", value, "VILLAGE_NAME", 0);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageNameRightLike(String value) {
            addCriterion("VILLAGE_NAME like ", value, "VILLAGE_NAME", 2);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageNameNotRightLike(String value) {
            addCriterion("VILLAGE_NAME  not like ", value, "VILLAGE_NAME", 2);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageNameIn(List<String> values) {
            addCriterion("VILLAGE_NAME  in ", values, "VILLAGE_NAME");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageNameNotIn(List<String> values) {
            addCriterion("VILLAGE_NAME not in ", values, "VILLAGE_NAME");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageNameBetween(String value1, String value2) {
            addCriterion("VILLAGE_NAME between ", value1, value2, "VILLAGE_NAME");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVillageNameNotBetween(String value1, String value2) {
            addCriterion("VILLAGE_NAME not between ", value1, value2, "VILLAGE_NAME");
            return (CodeVisitedTeamRankCriteria) this;
        }
        public CodeVisitedTeamRankCriteria andTownIdIsNull() {
            addCriterion("TOWN_ID is null");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownIdIsNotNull() {
            addCriterion("TOWN_ID is not null");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownIdEqualTo(Integer value) {
            addCriterion("TOWN_ID =", value, "TOWN_ID");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownIdNotEqualTo(Integer value) {
            addCriterion("TOWN_ID <>", value, "TOWN_ID");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownIdGreaterThan(Integer value) {
            addCriterion("TOWN_ID >", value, "TOWN_ID");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("TOWN_ID >=", value, "TOWN_ID");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownIdLessThan(Integer value) {
            addCriterion("TOWN_ID <", value, "TOWN_ID");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownIdLessThanOrEqualTo(Integer value) {
            addCriterion("TOWN_ID <=", value, "TOWN_ID");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownIdLike(Integer value) {
            addCriterion("TOWN_ID like ", value, "TOWN_ID", 1);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownIdNotLike(Integer value) {
            addCriterion("TOWN_ID  not like ", value, "TOWN_ID", 1);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownIdLeftLike(Integer value) {
            addCriterion("TOWN_ID like ", value, "TOWN_ID", 0);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownIdNotLeftLike(Integer value) {
            addCriterion("TOWN_ID  not like ", value, "TOWN_ID", 0);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownIdRightLike(Integer value) {
            addCriterion("TOWN_ID like ", value, "TOWN_ID", 2);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownIdNotRightLike(Integer value) {
            addCriterion("TOWN_ID  not like ", value, "TOWN_ID", 2);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownIdIn(List<Integer> values) {
            addCriterion("TOWN_ID  in ", values, "TOWN_ID");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownIdNotIn(List<Integer> values) {
            addCriterion("TOWN_ID not in ", values, "TOWN_ID");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownIdBetween(Integer value1, Integer value2) {
            addCriterion("TOWN_ID between ", value1, value2, "TOWN_ID");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownIdNotBetween(Integer value1, Integer value2) {
            addCriterion("TOWN_ID not between ", value1, value2, "TOWN_ID");
            return (CodeVisitedTeamRankCriteria) this;
        }
        public CodeVisitedTeamRankCriteria andTownNameIsNull() {
            addCriterion("TOWN_NAME is null");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownNameIsNotNull() {
            addCriterion("TOWN_NAME is not null");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownNameEqualTo(String value) {
            addCriterion("TOWN_NAME =", value, "TOWN_NAME");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownNameNotEqualTo(String value) {
            addCriterion("TOWN_NAME <>", value, "TOWN_NAME");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownNameGreaterThan(String value) {
            addCriterion("TOWN_NAME >", value, "TOWN_NAME");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownNameGreaterThanOrEqualTo(String value) {
            addCriterion("TOWN_NAME >=", value, "TOWN_NAME");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownNameLessThan(String value) {
            addCriterion("TOWN_NAME <", value, "TOWN_NAME");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownNameLessThanOrEqualTo(String value) {
            addCriterion("TOWN_NAME <=", value, "TOWN_NAME");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownNameLike(String value) {
            addCriterion("TOWN_NAME like ", value, "TOWN_NAME", 1);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownNameNotLike(String value) {
            addCriterion("TOWN_NAME  not like ", value, "TOWN_NAME", 1);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownNameLeftLike(String value) {
            addCriterion("TOWN_NAME like ", value, "TOWN_NAME", 0);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownNameNotLeftLike(String value) {
            addCriterion("TOWN_NAME  not like ", value, "TOWN_NAME", 0);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownNameRightLike(String value) {
            addCriterion("TOWN_NAME like ", value, "TOWN_NAME", 2);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownNameNotRightLike(String value) {
            addCriterion("TOWN_NAME  not like ", value, "TOWN_NAME", 2);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownNameIn(List<String> values) {
            addCriterion("TOWN_NAME  in ", values, "TOWN_NAME");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownNameNotIn(List<String> values) {
            addCriterion("TOWN_NAME not in ", values, "TOWN_NAME");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownNameBetween(String value1, String value2) {
            addCriterion("TOWN_NAME between ", value1, value2, "TOWN_NAME");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andTownNameNotBetween(String value1, String value2) {
            addCriterion("TOWN_NAME not between ", value1, value2, "TOWN_NAME");
            return (CodeVisitedTeamRankCriteria) this;
        }
        public CodeVisitedTeamRankCriteria andVtimeIsNull() {
            addCriterion("vtime is null");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVtimeIsNotNull() {
            addCriterion("vtime is not null");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVtimeEqualTo(String value) {
            addCriterion("vtime =", value, "vtime");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVtimeNotEqualTo(String value) {
            addCriterion("vtime <>", value, "vtime");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVtimeGreaterThan(String value) {
            addCriterion("vtime >", value, "vtime");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVtimeGreaterThanOrEqualTo(String value) {
            addCriterion("vtime >=", value, "vtime");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVtimeLessThan(String value) {
            addCriterion("vtime <", value, "vtime");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVtimeLessThanOrEqualTo(String value) {
            addCriterion("vtime <=", value, "vtime");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVtimeLike(String value) {
            addCriterion("vtime like ", value, "vtime", 1);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVtimeNotLike(String value) {
            addCriterion("vtime  not like ", value, "vtime", 1);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVtimeLeftLike(String value) {
            addCriterion("vtime like ", value, "vtime", 0);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVtimeNotLeftLike(String value) {
            addCriterion("vtime  not like ", value, "vtime", 0);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVtimeRightLike(String value) {
            addCriterion("vtime like ", value, "vtime", 2);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVtimeNotRightLike(String value) {
            addCriterion("vtime  not like ", value, "vtime", 2);
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVtimeIn(List<String> values) {
            addCriterion("vtime  in ", values, "vtime");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVtimeNotIn(List<String> values) {
            addCriterion("vtime not in ", values, "vtime");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVtimeBetween(String value1, String value2) {
            addCriterion("vtime between ", value1, value2, "vtime");
            return (CodeVisitedTeamRankCriteria) this;
        }

        public CodeVisitedTeamRankCriteria andVtimeNotBetween(String value1, String value2) {
            addCriterion("vtime not between ", value1, value2, "vtime");
            return (CodeVisitedTeamRankCriteria) this;
        }

    }

    public static class CodeVisitedTeamRankCriteria extends GeneratedCriteria {

        protected CodeVisitedTeamRankCriteria() {
            super();
        }
    }

    public static class CodeVisitedTeamRankCriterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected CodeVisitedTeamRankCriterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }
        protected CodeVisitedTeamRankCriterion(String condition, Object value, int likeType) {
            this.condition = condition;
            if (likeType == 0) {
                this.value = "%" + value;
            }
            else if (likeType == 1) {
                this.value = "%" + value + "%";
            }
            else {
                this.value = value + "%";
            }
            this.typeHandler = null;
            this.singleValue = true;

        }

        protected CodeVisitedTeamRankCriterion(String condition, Object value,
                String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            }
            else {
                this.singleValue = true;
            }
        }

        protected CodeVisitedTeamRankCriterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected CodeVisitedTeamRankCriterion(String condition, Object value,
                Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected CodeVisitedTeamRankCriterion(String condition, Object value,
                Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}